import os
import openpyxl
import pandas as pd

files = os.listdir('./csv')
writer = pd.ExcelWriter('疫苗数据.xlsx')
for filename in files:
  data = pd.read_csv('csv/{}'.format(filename))
  name = filename.replace('.csv','')
  data.to_excel(writer,sheet_name=name,index=None)
writer.save()